﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="LearningDataset" targetNamespace="http://tempuri.org/LearningDataset.xsd" xmlns:mstns="http://tempuri.org/LearningDataset.xsd" xmlns="http://tempuri.org/LearningDataset.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="DataConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="DataConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ELearning.Data.Properties.Settings.GlobalReference.Default.DataConnectionString" Provider="System.Data.SQLite" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ImagesTableAdapter" GeneratorDataComponentClassName="ImagesTableAdapter" Name="Images" UserDataComponentName="ImagesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="main.Images" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[Images] WHERE (([ID] = @Original_ID) AND ((@IsNull_Data = 1 AND [Data] IS NULL) OR ([Data] = @Original_Data)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Data" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_Data" Precision="0" ProviderType="Binary" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[Images] ([Data]) VALUES (@Data)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Data" Precision="0" ProviderType="Binary" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [ID], [Data] FROM [Images]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[Images] SET [Data] = @Data WHERE (([ID] = @Original_ID) AND ((@IsNull_Data = 1 AND [Data] IS NULL) OR ([Data] = @Original_Data)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Data" Precision="0" ProviderType="Binary" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Data" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_Data" Precision="0" ProviderType="Binary" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Data" DataSetColumn="Data" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UserTopicProgressTableAdapter" GeneratorDataComponentClassName="UserTopicProgressTableAdapter" Name="UserTopicProgress" UserDataComponentName="UserTopicProgressTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="main.UserTopicProgress" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[UserTopicProgress] WHERE (([TopicID] = @Original_TopicID) AND ([UserID] = @Original_UserID) AND ((@IsNull_Progress = 1 AND [Progress] IS NULL) OR ([Progress] = @Original_Progress)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_TopicID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="TopicID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Progress" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Progress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_Progress" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="Progress" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[UserTopicProgress] ([TopicID], [UserID], [Progress]) VALUES (@TopicID, @UserID, @Progress)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@TopicID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="TopicID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Progress" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="Progress" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [TopicID], [UserID], [Progress] FROM [UserTopicProgress]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[UserTopicProgress] SET [TopicID] = @TopicID, [UserID] = @UserID, [Progress] = @Progress WHERE (([TopicID] = @Original_TopicID) AND ([UserID] = @Original_UserID) AND ((@IsNull_Progress = 1 AND [Progress] IS NULL) OR ([Progress] = @Original_Progress)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@TopicID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="TopicID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Progress" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="Progress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_TopicID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="TopicID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Progress" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Progress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_Progress" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="Progress" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TopicID" DataSetColumn="TopicID" />
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="Progress" DataSetColumn="Progress" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SubjectsTableAdapter" GeneratorDataComponentClassName="SubjectsTableAdapter" Name="Subjects" UserDataComponentName="SubjectsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="main.Subjects" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[Subjects] WHERE (([ID] = @Original_ID) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[Subjects] ([Name]) VALUES (@Name)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [ID], [Name] FROM [Subjects]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[Subjects] SET [Name] = @Name WHERE (([ID] = @Original_ID) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SubtopicsTableAdapter" GeneratorDataComponentClassName="SubtopicsTableAdapter" Name="Subtopics" UserDataComponentName="SubtopicsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="main.Subtopics" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[Subtopics] WHERE (([ID] = @Original_ID) AND ([TopicID] = @Original_TopicID) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Order = 1 AND [Order] IS NULL) OR ([Order] = @Original_Order)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_TopicID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="TopicID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Order" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_Order" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[Subtopics] ([TopicID], [Name], [Order]) VALUES (@TopicID, @Name, @Order)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@TopicID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="TopicID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Order" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [ID], [TopicID], [Name], [Order] FROM [Subtopics]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[Subtopics] SET [TopicID] = @TopicID, [Name] = @Name, [Order] = @Order WHERE (([ID] = @Original_ID) AND ([TopicID] = @Original_TopicID) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Order = 1 AND [Order] IS NULL) OR ([Order] = @Original_Order)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@TopicID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="TopicID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Order" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_TopicID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="TopicID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Order" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_Order" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="TopicID" DataSetColumn="TopicID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Order" DataSetColumn="Order" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TestLinksTableAdapter" GeneratorDataComponentClassName="TestLinksTableAdapter" Name="TestLinks" UserDataComponentName="TestLinksTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="main.TestLinks" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[TestLinks] WHERE (([TopicID] = @Original_TopicID) AND ([ReferredTestID] = @Original_ReferredTestID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_TopicID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="TopicID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ReferredTestID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ReferredTestID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[TestLinks] ([TopicID], [ReferredTestID]) VALUES (@TopicID, @ReferredTestID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@TopicID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="TopicID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ReferredTestID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ReferredTestID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [TopicID], [ReferredTestID] FROM [TestLinks]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[TestLinks] SET [TopicID] = @TopicID, [ReferredTestID] = @ReferredTestID WHERE (([TopicID] = @Original_TopicID) AND ([ReferredTestID] = @Original_ReferredTestID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@TopicID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="TopicID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ReferredTestID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ReferredTestID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_TopicID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="TopicID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ReferredTestID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ReferredTestID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TopicID" DataSetColumn="TopicID" />
              <Mapping SourceColumn="ReferredTestID" DataSetColumn="ReferredTestID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TestsTableAdapter" GeneratorDataComponentClassName="TestsTableAdapter" Name="Tests" UserDataComponentName="TestsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="main.Tests" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[Tests] WHERE (([ID] = @Original_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[Tests] ([SubjectID], [Name], [BinaryData]) VALUES (@SubjectID, @Name, @BinaryData)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@SubjectID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="SubjectID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@BinaryData" Precision="0" ProviderType="Binary" Scale="0" Size="0" SourceColumn="BinaryData" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ID, SubjectID, Name, BinaryData
FROM            Tests</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[Tests] SET [SubjectID] = @SubjectID, [Name] = @Name, [BinaryData] = @BinaryData WHERE (([ID] = @Original_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@SubjectID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="SubjectID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@BinaryData" Precision="0" ProviderType="Binary" Scale="0" Size="0" SourceColumn="BinaryData" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="SubjectID" DataSetColumn="SubjectID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="BinaryData" DataSetColumn="BinaryData" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="main.Tests" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByID" GeneratorSourceName="FillByID" GetMethodModifier="Public" GetMethodName="GetDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByID" UserSourceName="FillByID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT BinaryData, ID, Name, SubjectID FROM Tests WHERE (ID = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="ID" DataSourceName="main.Tests" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="main.Tests" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBySubjectID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBySubjectID" GeneratorSourceName="FillBySubjectID" GetMethodModifier="Public" GetMethodName="GetDataBySubjectID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBySubjectID" UserSourceName="FillBySubjectID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT BinaryData, ID, Name, SubjectID FROM Tests WHERE (SubjectID = @subjectId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="subjectId" ColumnName="SubjectID" DataSourceName="main.Tests" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@subjectId" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="SubjectID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TextTableAdapter" GeneratorDataComponentClassName="TextTableAdapter" Name="Text" UserDataComponentName="TextTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="main.Text" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[Text] WHERE (([ID] = @Original_ID) AND ([SubtopicID] = @Original_SubtopicID) AND ((@IsNull_Text = 1 AND [Text] IS NULL) OR ([Text] = @Original_Text)) AND ((@IsNull_ImageID = 1 AND [ImageID] IS NULL) OR ([ImageID] = @Original_ImageID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_SubtopicID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="SubtopicID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Text" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Text" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Text" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Text" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ImageID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ImageID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ImageID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ImageID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[Text] ([SubtopicID], [Text], [ImageID]) VALUES (@SubtopicID, @Text, @ImageID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@SubtopicID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="SubtopicID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Text" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Text" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ImageID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ImageID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [ID], [SubtopicID], [Text], [ImageID] FROM [Text]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[Text] SET [SubtopicID] = @SubtopicID, [Text] = @Text, [ImageID] = @ImageID WHERE (([ID] = @Original_ID) AND ([SubtopicID] = @Original_SubtopicID) AND ((@IsNull_Text = 1 AND [Text] IS NULL) OR ([Text] = @Original_Text)) AND ((@IsNull_ImageID = 1 AND [ImageID] IS NULL) OR ([ImageID] = @Original_ImageID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@SubtopicID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="SubtopicID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Text" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Text" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ImageID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ImageID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_SubtopicID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="SubtopicID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Text" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Text" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Text" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Text" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ImageID" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ImageID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ImageID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ImageID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="SubtopicID" DataSetColumn="SubtopicID" />
              <Mapping SourceColumn="Text" DataSetColumn="Text" />
              <Mapping SourceColumn="ImageID" DataSetColumn="ImageID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TopicLinksTableAdapter" GeneratorDataComponentClassName="TopicLinksTableAdapter" Name="TopicLinks" UserDataComponentName="TopicLinksTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="main.TopicLinks" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[TopicLinks] WHERE (([TopicID] = @Original_TopicID) AND ([ReferredTopic] = @Original_ReferredTopic))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_TopicID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="TopicID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ReferredTopic" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ReferredTopic" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[TopicLinks] ([TopicID], [ReferredTopic]) VALUES (@TopicID, @ReferredTopic)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@TopicID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="TopicID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ReferredTopic" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ReferredTopic" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [TopicID], [ReferredTopic] FROM [TopicLinks]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[TopicLinks] SET [TopicID] = @TopicID, [ReferredTopic] = @ReferredTopic WHERE (([TopicID] = @Original_TopicID) AND ([ReferredTopic] = @Original_ReferredTopic))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@TopicID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="TopicID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ReferredTopic" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ReferredTopic" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_TopicID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="TopicID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ReferredTopic" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ReferredTopic" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TopicID" DataSetColumn="TopicID" />
              <Mapping SourceColumn="ReferredTopic" DataSetColumn="ReferredTopic" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TopicsTableAdapter" GeneratorDataComponentClassName="TopicsTableAdapter" Name="Topics" UserDataComponentName="TopicsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="main.Topics" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[Topics] WHERE (([ID] = @Original_ID) AND ([SubjectID] = @Original_SubjectID) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Order = 1 AND [Order] IS NULL) OR ([Order] = @Original_Order)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_SubjectID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="SubjectID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Order" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_Order" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[Topics] ([SubjectID], [Name], [Order]) VALUES (@SubjectID, @Name, @Order)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@SubjectID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="SubjectID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Order" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [ID], [SubjectID], [Name], [Order] FROM [Topics]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[Topics] SET [SubjectID] = @SubjectID, [Name] = @Name, [Order] = @Order WHERE (([ID] = @Original_ID) AND ([SubjectID] = @Original_SubjectID) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Order = 1 AND [Order] IS NULL) OR ([Order] = @Original_Order)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@SubjectID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="SubjectID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Order" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_SubjectID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="SubjectID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Order" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_Order" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="SubjectID" DataSetColumn="SubjectID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Order" DataSetColumn="Order" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersTableAdapter" GeneratorDataComponentClassName="UsersTableAdapter" Name="Users" UserDataComponentName="UsersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="main.Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[Users] WHERE (([ID] = @Original_ID) AND ((@IsNull_Login = 1 AND [Login] IS NULL) OR ([Login] = @Original_Login)) AND ((@IsNull_PasswordHash = 1 AND [PasswordHash] IS NULL) OR ([PasswordHash] = @Original_PasswordHash)) AND ((@IsNull_LastAccessDate = 1 AND [LastAccessDate] IS NULL) OR ([LastAccessDate] = @Original_LastAccessDate)) AND ((@IsNull_AvailableDisciplines = 1 AND [AvailableDisciplines] IS NULL) OR ([AvailableDisciplines] = @Original_AvailableDisciplines)) AND ((@IsNull_IsAdministrator = 1 AND [IsAdministrator] IS NULL) OR ([IsAdministrator] = @Original_IsAdministrator)) AND ((@IsNull_FullName = 1 AND [FullName] IS NULL) OR ([FullName] = @Original_FullName)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Login" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Login" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PasswordHash" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="PasswordHash" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PasswordHash" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="PasswordHash" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastAccessDate" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="LastAccessDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LastAccessDate" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="LastAccessDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AvailableDisciplines" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="AvailableDisciplines" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AvailableDisciplines" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="AvailableDisciplines" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IsAdministrator" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="IsAdministrator" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsAdministrator" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsAdministrator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FullName" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FullName" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[Users] ([Login], [PasswordHash], [LastAccessDate], [AvailableDisciplines], [IsAdministrator], [FullName]) VALUES (@Login, @PasswordHash, @LastAccessDate, @AvailableDisciplines, @IsAdministrator, @FullName)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Login" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PasswordHash" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="PasswordHash" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LastAccessDate" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="LastAccessDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AvailableDisciplines" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="AvailableDisciplines" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsAdministrator" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsAdministrator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FullName" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [ID], [Login], [PasswordHash], [LastAccessDate], [AvailableDisciplines], [IsAdministrator], [FullName] FROM [Users]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[Users] SET [Login] = @Login, [PasswordHash] = @PasswordHash, [LastAccessDate] = @LastAccessDate, [AvailableDisciplines] = @AvailableDisciplines, [IsAdministrator] = @IsAdministrator, [FullName] = @FullName WHERE (([ID] = @Original_ID) AND ((@IsNull_Login = 1 AND [Login] IS NULL) OR ([Login] = @Original_Login)) AND ((@IsNull_PasswordHash = 1 AND [PasswordHash] IS NULL) OR ([PasswordHash] = @Original_PasswordHash)) AND ((@IsNull_LastAccessDate = 1 AND [LastAccessDate] IS NULL) OR ([LastAccessDate] = @Original_LastAccessDate)) AND ((@IsNull_AvailableDisciplines = 1 AND [AvailableDisciplines] IS NULL) OR ([AvailableDisciplines] = @Original_AvailableDisciplines)) AND ((@IsNull_IsAdministrator = 1 AND [IsAdministrator] IS NULL) OR ([IsAdministrator] = @Original_IsAdministrator)) AND ((@IsNull_FullName = 1 AND [FullName] IS NULL) OR ([FullName] = @Original_FullName)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Login" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PasswordHash" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="PasswordHash" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LastAccessDate" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="LastAccessDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AvailableDisciplines" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="AvailableDisciplines" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsAdministrator" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsAdministrator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FullName" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Login" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Login" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PasswordHash" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="PasswordHash" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PasswordHash" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="PasswordHash" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastAccessDate" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="LastAccessDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LastAccessDate" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="LastAccessDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AvailableDisciplines" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="AvailableDisciplines" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AvailableDisciplines" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="AvailableDisciplines" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IsAdministrator" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="IsAdministrator" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsAdministrator" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsAdministrator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FullName" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FullName" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Login" DataSetColumn="Login" />
              <Mapping SourceColumn="PasswordHash" DataSetColumn="PasswordHash" />
              <Mapping SourceColumn="LastAccessDate" DataSetColumn="LastAccessDate" />
              <Mapping SourceColumn="AvailableDisciplines" DataSetColumn="AvailableDisciplines" />
              <Mapping SourceColumn="IsAdministrator" DataSetColumn="IsAdministrator" />
              <Mapping SourceColumn="FullName" DataSetColumn="FullName" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="main.Users" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="GetAvailibleSubjects" Modifier="Public" Name="GetAvailibleSubjects" QueryType="Scalar" ScalarCallRetval="System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetAvailibleSubjects">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        AvailableDisciplines
FROM            Users
WHERE        (ID = @userId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="userId" ColumnName="ID" DataSourceName="main.Users" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@userId" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="main.Users" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="GetPasswordHash" Modifier="Public" Name="GetPasswordHash" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="GetPasswordHash">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        PasswordHash
FROM            Users
WHERE        (Login = @login)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="login" ColumnName="Login" DataSourceName="main.Users" DataTypeServer="text" DbType="String" Direction="Input" ParameterName="@login" Precision="0" ProviderType="String" Scale="0" Size="2147483647" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="main.Users" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="GetPasswordHashByID" Modifier="Public" Name="GetPasswordHashByID" QueryType="Scalar" ScalarCallRetval="System.Byte[], mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="GetPasswordHashByID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        PasswordHash
FROM            Users
WHERE        (ID = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="ID" DataSourceName="main.Users" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="main.Users" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="GetUserID" Modifier="Public" Name="GetUserID" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="GetUserID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        ID
FROM            Users
WHERE        (Login = @login)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="login" ColumnName="Login" DataSourceName="main.Users" DataTypeServer="text" DbType="String" Direction="Input" ParameterName="@login" Precision="0" ProviderType="String" Scale="0" Size="2147483647" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetUsersCount" Modifier="Public" Name="GetUsersCount" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="GetUsersCount">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        COUNT(*) AS Expr1
FROM            Users</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="main.Users" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="IsAdmin" Modifier="Public" Name="IsAdmin" QueryType="Scalar" ScalarCallRetval="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy5" UserSourceName="IsAdmin">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IsAdministrator
FROM            Users
WHERE        (ID = @userId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="userId" ColumnName="ID" DataSourceName="main.Users" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@userId" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="SelectUserCount" Modifier="Public" Name="SelectUserCount" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy6" UserSourceName="SelectUserCount">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        COUNT(*) AS Expr1
FROM            Users
WHERE        (Login = @login)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="login" ColumnName="Login" DataSourceName="main.Users" DataTypeServer="text" DbType="String" Direction="Input" ParameterName="@login" Precision="0" ProviderType="String" Scale="0" Size="2147483647" SourceColumn="Login" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateLastAccessDate" Modifier="Public" Name="UpdateLastAccessDate" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy7" UserSourceName="UpdateLastAccessDate">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       Users
SET                LastAccessDate = @lastAccessDate
WHERE        (ID = @Original_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="lastAccessDate" ColumnName="LastAccessDate" DataSourceName="main.Users" DataTypeServer="text" DbType="String" Direction="Input" ParameterName="@lastAccessDate" Precision="0" ProviderType="String" Scale="0" Size="2147483647" SourceColumn="LastAccessDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_ID" ColumnName="ID" DataSourceName="main.Users" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdatePasswordHash" Modifier="Public" Name="UpdatePasswordHash" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy8" UserSourceName="UpdatePasswordHash">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       Users
SET                PasswordHash = @newHash
WHERE        (ID = @Original_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="newHash" ColumnName="PasswordHash" DataSourceName="main.Users" DataTypeServer="text" DbType="Binary" Direction="Input" ParameterName="@newHash" Precision="0" ProviderType="Binary" Scale="0" Size="2147483647" SourceColumn="PasswordHash" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_ID" ColumnName="ID" DataSourceName="main.Users" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UserTestsProgressTableAdapter" GeneratorDataComponentClassName="UserTestsProgressTableAdapter" Name="UserTestsProgress" UserDataComponentName="UserTestsProgressTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DataConnectionString (Settings)" DbObjectName="main.UserTestsProgress" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[UserTestsProgress] WHERE (([TestID] = @Original_TestID) AND ([UserID] = @Original_UserID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_TestID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="TestID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[UserTestsProgress] ([TestID], [UserID]) VALUES (@TestID, @UserID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@TestID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="TestID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [TestID], [UserID] FROM [UserTestsProgress]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[UserTestsProgress] SET [TestID] = @TestID, [UserID] = @UserID WHERE (([TestID] = @Original_TestID) AND ([UserID] = @Original_UserID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@TestID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="TestID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_TestID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="TestID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="TestID" DataSetColumn="TestID" />
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="LearningDataset" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="LearningDataset" msprop:Generator_UserDSName="LearningDataset">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Images" msprop:Generator_TableClassName="ImagesDataTable" msprop:Generator_TableVarName="tableImages" msprop:Generator_RowChangedName="ImagesRowChanged" msprop:Generator_TablePropName="Images" msprop:Generator_RowDeletingName="ImagesRowDeleting" msprop:Generator_RowChangingName="ImagesRowChanging" msprop:Generator_RowEvHandlerName="ImagesRowChangeEventHandler" msprop:Generator_RowDeletedName="ImagesRowDeleted" msprop:Generator_RowClassName="ImagesRow" msprop:Generator_UserTableName="Images" msprop:Generator_RowEvArgName="ImagesRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:long" />
              <xs:element name="Data" msprop:Generator_ColumnVarNameInTable="columnData" msprop:Generator_ColumnPropNameInRow="Data" msprop:Generator_ColumnPropNameInTable="DataColumn" msprop:Generator_UserColumnName="Data" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="UserTopicProgress" msprop:Generator_TableClassName="UserTopicProgressDataTable" msprop:Generator_TableVarName="tableUserTopicProgress" msprop:Generator_RowChangedName="UserTopicProgressRowChanged" msprop:Generator_TablePropName="UserTopicProgress" msprop:Generator_RowDeletingName="UserTopicProgressRowDeleting" msprop:Generator_RowChangingName="UserTopicProgressRowChanging" msprop:Generator_RowEvHandlerName="UserTopicProgressRowChangeEventHandler" msprop:Generator_RowDeletedName="UserTopicProgressRowDeleted" msprop:Generator_RowClassName="UserTopicProgressRow" msprop:Generator_UserTableName="UserTopicProgress" msprop:Generator_RowEvArgName="UserTopicProgressRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TopicID" msprop:Generator_ColumnVarNameInTable="columnTopicID" msprop:Generator_ColumnPropNameInRow="TopicID" msprop:Generator_ColumnPropNameInTable="TopicIDColumn" msprop:Generator_UserColumnName="TopicID" type="xs:long" />
              <xs:element name="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_UserColumnName="UserID" type="xs:long" />
              <xs:element name="Progress" msprop:Generator_ColumnVarNameInTable="columnProgress" msprop:Generator_ColumnPropNameInRow="Progress" msprop:Generator_ColumnPropNameInTable="ProgressColumn" msprop:Generator_UserColumnName="Progress" type="xs:long" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Subjects" msprop:Generator_TableClassName="SubjectsDataTable" msprop:Generator_TableVarName="tableSubjects" msprop:Generator_RowChangedName="SubjectsRowChanged" msprop:Generator_TablePropName="Subjects" msprop:Generator_RowDeletingName="SubjectsRowDeleting" msprop:Generator_RowChangingName="SubjectsRowChanging" msprop:Generator_RowEvHandlerName="SubjectsRowChangeEventHandler" msprop:Generator_RowDeletedName="SubjectsRowDeleted" msprop:Generator_RowClassName="SubjectsRow" msprop:Generator_UserTableName="Subjects" msprop:Generator_RowEvArgName="SubjectsRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:long" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Subtopics" msprop:Generator_TableClassName="SubtopicsDataTable" msprop:Generator_TableVarName="tableSubtopics" msprop:Generator_RowChangedName="SubtopicsRowChanged" msprop:Generator_TablePropName="Subtopics" msprop:Generator_RowDeletingName="SubtopicsRowDeleting" msprop:Generator_RowChangingName="SubtopicsRowChanging" msprop:Generator_RowEvHandlerName="SubtopicsRowChangeEventHandler" msprop:Generator_RowDeletedName="SubtopicsRowDeleted" msprop:Generator_RowClassName="SubtopicsRow" msprop:Generator_UserTableName="Subtopics" msprop:Generator_RowEvArgName="SubtopicsRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:long" />
              <xs:element name="TopicID" msprop:Generator_ColumnVarNameInTable="columnTopicID" msprop:Generator_ColumnPropNameInRow="TopicID" msprop:Generator_ColumnPropNameInTable="TopicIDColumn" msprop:Generator_UserColumnName="TopicID" type="xs:long" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Order" msprop:Generator_ColumnVarNameInTable="columnOrder" msprop:Generator_ColumnPropNameInRow="Order" msprop:Generator_ColumnPropNameInTable="OrderColumn" msprop:Generator_UserColumnName="Order" type="xs:long" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TestLinks" msprop:Generator_TableClassName="TestLinksDataTable" msprop:Generator_TableVarName="tableTestLinks" msprop:Generator_RowChangedName="TestLinksRowChanged" msprop:Generator_TablePropName="TestLinks" msprop:Generator_RowDeletingName="TestLinksRowDeleting" msprop:Generator_RowChangingName="TestLinksRowChanging" msprop:Generator_RowEvHandlerName="TestLinksRowChangeEventHandler" msprop:Generator_RowDeletedName="TestLinksRowDeleted" msprop:Generator_RowClassName="TestLinksRow" msprop:Generator_UserTableName="TestLinks" msprop:Generator_RowEvArgName="TestLinksRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TopicID" msprop:Generator_ColumnVarNameInTable="columnTopicID" msprop:Generator_ColumnPropNameInRow="TopicID" msprop:Generator_ColumnPropNameInTable="TopicIDColumn" msprop:Generator_UserColumnName="TopicID" type="xs:long" />
              <xs:element name="ReferredTestID" msprop:Generator_ColumnVarNameInTable="columnReferredTestID" msprop:Generator_ColumnPropNameInRow="ReferredTestID" msprop:Generator_ColumnPropNameInTable="ReferredTestIDColumn" msprop:Generator_UserColumnName="ReferredTestID" type="xs:long" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Tests" msprop:Generator_TableClassName="TestsDataTable" msprop:Generator_TableVarName="tableTests" msprop:Generator_RowChangedName="TestsRowChanged" msprop:Generator_TablePropName="Tests" msprop:Generator_RowDeletingName="TestsRowDeleting" msprop:Generator_RowChangingName="TestsRowChanging" msprop:Generator_RowEvHandlerName="TestsRowChangeEventHandler" msprop:Generator_RowDeletedName="TestsRowDeleted" msprop:Generator_RowClassName="TestsRow" msprop:Generator_UserTableName="Tests" msprop:Generator_RowEvArgName="TestsRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:long" />
              <xs:element name="SubjectID" msprop:Generator_ColumnVarNameInTable="columnSubjectID" msprop:Generator_ColumnPropNameInRow="SubjectID" msprop:Generator_ColumnPropNameInTable="SubjectIDColumn" msprop:Generator_UserColumnName="SubjectID" type="xs:long" minOccurs="0" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BinaryData" msprop:Generator_ColumnVarNameInTable="columnBinaryData" msprop:Generator_ColumnPropNameInRow="BinaryData" msprop:Generator_ColumnPropNameInTable="BinaryDataColumn" msprop:Generator_UserColumnName="BinaryData" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Text" msprop:Generator_TableClassName="TextDataTable" msprop:Generator_TableVarName="tableText" msprop:Generator_RowChangedName="TextRowChanged" msprop:Generator_TablePropName="Text" msprop:Generator_RowDeletingName="TextRowDeleting" msprop:Generator_RowChangingName="TextRowChanging" msprop:Generator_RowEvHandlerName="TextRowChangeEventHandler" msprop:Generator_RowDeletedName="TextRowDeleted" msprop:Generator_RowClassName="TextRow" msprop:Generator_UserTableName="Text" msprop:Generator_RowEvArgName="TextRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:long" />
              <xs:element name="SubtopicID" msprop:Generator_ColumnVarNameInTable="columnSubtopicID" msprop:Generator_ColumnPropNameInRow="SubtopicID" msprop:Generator_ColumnPropNameInTable="SubtopicIDColumn" msprop:Generator_UserColumnName="SubtopicID" type="xs:long" />
              <xs:element name="Text" msprop:Generator_ColumnVarNameInTable="columnText" msprop:Generator_ColumnPropNameInRow="Text" msprop:Generator_ColumnPropNameInTable="TextColumn" msprop:Generator_UserColumnName="Text" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ImageID" msprop:Generator_ColumnVarNameInTable="columnImageID" msprop:Generator_ColumnPropNameInRow="ImageID" msprop:Generator_ColumnPropNameInTable="ImageIDColumn" msprop:Generator_UserColumnName="ImageID" type="xs:long" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TopicLinks" msprop:Generator_TableClassName="TopicLinksDataTable" msprop:Generator_TableVarName="tableTopicLinks" msprop:Generator_RowChangedName="TopicLinksRowChanged" msprop:Generator_TablePropName="TopicLinks" msprop:Generator_RowDeletingName="TopicLinksRowDeleting" msprop:Generator_RowChangingName="TopicLinksRowChanging" msprop:Generator_RowEvHandlerName="TopicLinksRowChangeEventHandler" msprop:Generator_RowDeletedName="TopicLinksRowDeleted" msprop:Generator_RowClassName="TopicLinksRow" msprop:Generator_UserTableName="TopicLinks" msprop:Generator_RowEvArgName="TopicLinksRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TopicID" msprop:Generator_ColumnVarNameInTable="columnTopicID" msprop:Generator_ColumnPropNameInRow="TopicID" msprop:Generator_ColumnPropNameInTable="TopicIDColumn" msprop:Generator_UserColumnName="TopicID" type="xs:long" />
              <xs:element name="ReferredTopic" msprop:Generator_ColumnVarNameInTable="columnReferredTopic" msprop:Generator_ColumnPropNameInRow="ReferredTopic" msprop:Generator_ColumnPropNameInTable="ReferredTopicColumn" msprop:Generator_UserColumnName="ReferredTopic" type="xs:long" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Topics" msprop:Generator_TableClassName="TopicsDataTable" msprop:Generator_TableVarName="tableTopics" msprop:Generator_RowChangedName="TopicsRowChanged" msprop:Generator_TablePropName="Topics" msprop:Generator_RowDeletingName="TopicsRowDeleting" msprop:Generator_RowChangingName="TopicsRowChanging" msprop:Generator_RowEvHandlerName="TopicsRowChangeEventHandler" msprop:Generator_RowDeletedName="TopicsRowDeleted" msprop:Generator_RowClassName="TopicsRow" msprop:Generator_UserTableName="Topics" msprop:Generator_RowEvArgName="TopicsRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:long" />
              <xs:element name="SubjectID" msprop:Generator_ColumnVarNameInTable="columnSubjectID" msprop:Generator_ColumnPropNameInRow="SubjectID" msprop:Generator_ColumnPropNameInTable="SubjectIDColumn" msprop:Generator_UserColumnName="SubjectID" type="xs:long" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Order" msprop:Generator_ColumnVarNameInTable="columnOrder" msprop:Generator_ColumnPropNameInRow="Order" msprop:Generator_ColumnPropNameInTable="OrderColumn" msprop:Generator_UserColumnName="Order" type="xs:long" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Users" msprop:Generator_TableClassName="UsersDataTable" msprop:Generator_TableVarName="tableUsers" msprop:Generator_RowChangedName="UsersRowChanged" msprop:Generator_TablePropName="Users" msprop:Generator_RowDeletingName="UsersRowDeleting" msprop:Generator_RowChangingName="UsersRowChanging" msprop:Generator_RowEvHandlerName="UsersRowChangeEventHandler" msprop:Generator_RowDeletedName="UsersRowDeleted" msprop:Generator_RowClassName="UsersRow" msprop:Generator_UserTableName="Users" msprop:Generator_RowEvArgName="UsersRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:long" />
              <xs:element name="Login" msprop:Generator_ColumnVarNameInTable="columnLogin" msprop:Generator_ColumnPropNameInRow="Login" msprop:Generator_ColumnPropNameInTable="LoginColumn" msprop:Generator_UserColumnName="Login" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PasswordHash" msprop:Generator_ColumnVarNameInTable="columnPasswordHash" msprop:Generator_ColumnPropNameInRow="PasswordHash" msprop:Generator_ColumnPropNameInTable="PasswordHashColumn" msprop:Generator_UserColumnName="PasswordHash" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="LastAccessDate" msprop:Generator_ColumnVarNameInTable="columnLastAccessDate" msprop:Generator_ColumnPropNameInRow="LastAccessDate" msprop:Generator_ColumnPropNameInTable="LastAccessDateColumn" msprop:Generator_UserColumnName="LastAccessDate" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AvailableDisciplines" msprop:Generator_ColumnVarNameInTable="columnAvailableDisciplines" msprop:Generator_ColumnPropNameInRow="AvailableDisciplines" msprop:Generator_ColumnPropNameInTable="AvailableDisciplinesColumn" msprop:Generator_UserColumnName="AvailableDisciplines" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsAdministrator" msprop:Generator_ColumnVarNameInTable="columnIsAdministrator" msprop:Generator_ColumnPropNameInRow="IsAdministrator" msprop:Generator_ColumnPropNameInTable="IsAdministratorColumn" msprop:Generator_UserColumnName="IsAdministrator" type="xs:boolean" minOccurs="0" />
              <xs:element name="FullName" msprop:Generator_ColumnVarNameInTable="columnFullName" msprop:Generator_ColumnPropNameInRow="FullName" msprop:Generator_ColumnPropNameInTable="FullNameColumn" msprop:Generator_UserColumnName="FullName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="UserTestsProgress" msprop:Generator_TableClassName="UserTestsProgressDataTable" msprop:Generator_TableVarName="tableUserTestsProgress" msprop:Generator_RowChangedName="UserTestsProgressRowChanged" msprop:Generator_TablePropName="UserTestsProgress" msprop:Generator_RowDeletingName="UserTestsProgressRowDeleting" msprop:Generator_RowChangingName="UserTestsProgressRowChanging" msprop:Generator_RowEvHandlerName="UserTestsProgressRowChangeEventHandler" msprop:Generator_RowDeletedName="UserTestsProgressRowDeleted" msprop:Generator_RowClassName="UserTestsProgressRow" msprop:Generator_UserTableName="UserTestsProgress" msprop:Generator_RowEvArgName="UserTestsProgressRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="TestID" msprop:Generator_ColumnVarNameInTable="columnTestID" msprop:Generator_ColumnPropNameInRow="TestID" msprop:Generator_ColumnPropNameInTable="TestIDColumn" msprop:Generator_UserColumnName="TestID" type="xs:long" />
              <xs:element name="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_UserColumnName="UserID" type="xs:long" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Images" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="UserTopicProgress_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UserTopicProgress" />
      <xs:field xpath="mstns:TopicID" />
      <xs:field xpath="mstns:UserID" />
    </xs:unique>
    <xs:unique name="Subjects_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Subjects" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Subtopics_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Subtopics" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="TestLinks_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TestLinks" />
      <xs:field xpath="mstns:TopicID" />
      <xs:field xpath="mstns:ReferredTestID" />
    </xs:unique>
    <xs:unique name="Tests_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Tests" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Text_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Text" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="TopicLinks_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TopicLinks" />
      <xs:field xpath="mstns:TopicID" />
      <xs:field xpath="mstns:ReferredTopic" />
    </xs:unique>
    <xs:unique name="Topics_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Topics" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Users_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Users" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="UserTestsProgress_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UserTestsProgress" />
      <xs:field xpath="mstns:TestID" />
      <xs:field xpath="mstns:UserID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_UserTopicProgress_0_0" msdata:parent="Users" msdata:child="UserTopicProgress" msdata:parentkey="ID" msdata:childkey="UserID" msprop:Generator_UserChildTable="UserTopicProgress" msprop:Generator_ChildPropName="GetUserTopicProgressRows" msprop:Generator_UserRelationName="FK_UserTopicProgress_0_0" msprop:Generator_ParentPropName="UsersRow" msprop:Generator_RelationVarName="relationFK_UserTopicProgress_0_0" msprop:Generator_UserParentTable="Users" />
      <msdata:Relationship name="FK_UserTopicProgress_1_0" msdata:parent="Topics" msdata:child="UserTopicProgress" msdata:parentkey="ID" msdata:childkey="TopicID" msprop:Generator_UserChildTable="UserTopicProgress" msprop:Generator_ChildPropName="GetUserTopicProgressRows" msprop:Generator_UserRelationName="FK_UserTopicProgress_1_0" msprop:Generator_ParentPropName="TopicsRow" msprop:Generator_RelationVarName="relationFK_UserTopicProgress_1_0" msprop:Generator_UserParentTable="Topics" />
      <msdata:Relationship name="FK_Subtopics_0_0" msdata:parent="Topics" msdata:child="Subtopics" msdata:parentkey="ID" msdata:childkey="TopicID" msprop:Generator_UserChildTable="Subtopics" msprop:Generator_ChildPropName="GetSubtopicsRows" msprop:Generator_UserRelationName="FK_Subtopics_0_0" msprop:Generator_ParentPropName="TopicsRow" msprop:Generator_RelationVarName="relationFK_Subtopics_0_0" msprop:Generator_UserParentTable="Topics" />
      <msdata:Relationship name="FK_TestLinks_0_0" msdata:parent="Tests" msdata:child="TestLinks" msdata:parentkey="ID" msdata:childkey="ReferredTestID" msprop:Generator_UserChildTable="TestLinks" msprop:Generator_ChildPropName="GetTestLinksRows" msprop:Generator_UserRelationName="FK_TestLinks_0_0" msprop:Generator_ParentPropName="TestsRow" msprop:Generator_RelationVarName="relationFK_TestLinks_0_0" msprop:Generator_UserParentTable="Tests" />
      <msdata:Relationship name="FK_Tests_0_0" msdata:parent="Subjects" msdata:child="Tests" msdata:parentkey="ID" msdata:childkey="SubjectID" msprop:Generator_UserChildTable="Tests" msprop:Generator_ChildPropName="GetTestsRows" msprop:Generator_UserRelationName="FK_Tests_0_0" msprop:Generator_RelationVarName="relationFK_Tests_0_0" msprop:Generator_UserParentTable="Subjects" msprop:Generator_ParentPropName="SubjectsRow" />
      <msdata:Relationship name="FK_Text_0_0" msdata:parent="Images" msdata:child="Text" msdata:parentkey="ID" msdata:childkey="ImageID" msprop:Generator_UserChildTable="Text" msprop:Generator_ChildPropName="GetTextRows" msprop:Generator_UserRelationName="FK_Text_0_0" msprop:Generator_RelationVarName="relationFK_Text_0_0" msprop:Generator_UserParentTable="Images" msprop:Generator_ParentPropName="ImagesRow" />
      <msdata:Relationship name="FK_TopicLinks_0_0" msdata:parent="Topics" msdata:child="TopicLinks" msdata:parentkey="ID" msdata:childkey="ReferredTopic" msprop:Generator_UserChildTable="TopicLinks" msprop:Generator_ChildPropName="GetTopicLinksRowsByFK_TopicLinks_0_0" msprop:Generator_UserRelationName="FK_TopicLinks_0_0" msprop:Generator_ParentPropName="TopicsRowByFK_TopicLinks_0_0" msprop:Generator_RelationVarName="relationFK_TopicLinks_0_0" msprop:Generator_UserParentTable="Topics" />
      <msdata:Relationship name="FK_TopicLinks_1_0" msdata:parent="Topics" msdata:child="TopicLinks" msdata:parentkey="ID" msdata:childkey="TopicID" msprop:Generator_UserChildTable="TopicLinks" msprop:Generator_ChildPropName="GetTopicLinksRowsByFK_TopicLinks_1_0" msprop:Generator_UserRelationName="FK_TopicLinks_1_0" msprop:Generator_ParentPropName="TopicsRowByFK_TopicLinks_1_0" msprop:Generator_RelationVarName="relationFK_TopicLinks_1_0" msprop:Generator_UserParentTable="Topics" />
      <msdata:Relationship name="FK_Topics_0_0" msdata:parent="Subjects" msdata:child="Topics" msdata:parentkey="ID" msdata:childkey="SubjectID" msprop:Generator_UserChildTable="Topics" msprop:Generator_ChildPropName="GetTopicsRows" msprop:Generator_UserRelationName="FK_Topics_0_0" msprop:Generator_RelationVarName="relationFK_Topics_0_0" msprop:Generator_UserParentTable="Subjects" msprop:Generator_ParentPropName="SubjectsRow" />
      <msdata:Relationship name="FK_UserTestsProgress_0_0" msdata:parent="Tests" msdata:child="UserTestsProgress" msdata:parentkey="ID" msdata:childkey="TestID" msprop:Generator_UserChildTable="UserTestsProgress" msprop:Generator_ChildPropName="GetUserTestsProgressRows" msprop:Generator_UserRelationName="FK_UserTestsProgress_0_0" msprop:Generator_RelationVarName="relationFK_UserTestsProgress_0_0" msprop:Generator_UserParentTable="Tests" msprop:Generator_ParentPropName="TestsRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>